[dbo].[BAECheckIfStoredProcExists]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAECheckIfStoredProcExists

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@procName	varchar(64)	64

SQL Script

create procedure [dbo].[BAECheckIfStoredProcExists] @procName varchar(64) as
SELECT     name
FROM        sysobjects
WHERE    name = @procName and type='p'

GO

Uses

dbo
[dbo].[sysobjects]